<div class="Recommend_boxer borderbox" id="RecommendProp" style="height:350px">
<h3><a href="" class="more" rel="nofollow">更多北京二手房&nbsp;»</a>热门房源</h3>

<ul class="list">
<?php


			require_once ("./includes/configure.php");
			require_once ("./includes/database.php");

			$db = Database :: Connect();

			$sql = "select * from zufang where type=1 order by guanzhucishu desc limit 0,8"; //默认0为出租

			$rows = $db->GetResultSet($sql)  or die ("出错啦!");


			$num = mysql_num_rows($rows);

            if($num > 0){

			while ($row = mysql_fetch_array($rows)) {

				$id = $row['id'];

				$biaoti = $row['biaoti'];

				$xiaoquid = $row['xiaoqu'];

				$dizhi = $row['dizhi'];

				$jiage = $row['jiage'];

				$huxing = $row['huxing'];
				$huxing = explode('|', $huxing);
				$huxing_shi = $huxing[0] . '室';
				$huxing_ting = $huxing[1] . '厅';
				$huxing_wei = $huxing[2] . '卫';
				$huxing = $huxing_shi . $huxing_ting . $huxing_wei;

				$zhuangxiu = $row['zhuangxiu'];

				$louceng = $row['louceng'];

				$chuzufangshi = $row['zulin'];

				$jitui = $row['jitui'];

				$xintui = $row['xintui'];

				$duotu = $row['duotu'];

				$lianxiren = $row['lianxiren'];

				$fangling = $row['fangling'];


				$time = $row['time'];

				$tupian = $row['tupian'];
	            $tupian = explode(";",$tupian);

?>


	<li><a href="fangwu.php?id=<?php echo $id?>"  class="image"><img src="<?php echo './'.$tupian[0] ?>"
			width="100" height="75" onerror="this.src='./images/avatar.gif'"></a> <span class="sale_tag"></span>
	<p class="propinfo"><a href="fangwu.php?id=<?php echo $id?>"><?php echo $biaoti?><br>
	<?php echo $huxing.','.$mianji.'平米'?></a></p>
	<p class="price"><?php echo $jiage?>万元</p>
	</li>

<?php

}

			}




			$db->Close();
?>
	</ul>
</div>
